
run /Users/zerenli1992/Dropbox/anti_corruption/replication_file/pre_reg_clean

drop if year <2013


collapse ///
(max)  year winner_sec first_con_ps $prov_control provID1 purge_next ///
(last) purge_cen_cum  sec_promotion  sec_promotion_fat con_ps  $i_control  ///
(mean) fiscal_gdp_rel  gdp_pc_rel gdp_growth_rel fiscal_growth_rel ///
, by(name_x cityID)
 
g purgeconnection = first_con_ps*purge_cen_cum

 
lab var sec_promotion "Political Turnover"
lab var cityID "Prefecture"
lab var first_con_ps "Connection"
lab var purge_cen_cum "Purge Intensity"
lab var gdp_growth_rel "Relative GDP Growth Rate"
lab var fiscal_growth_rel "Relative Fiscal Growth Rate"
lab var gdp_pc_rel "Relative Economic Performance"
lab var fiscal_gdp_rel "Relative Fiscal Performance"
lab var sec_age "Age"
lab var sec_age_2 "Age^2"
lab var ps_term "Years in Office"
lab var ps_term_2 "Years in Office^2"
lab var female "Female"
lab var edu "College"
lab var dic "DIC"
lab  var minority "Minority"
lab var law_enforce "Court and Law Enforcement"
lab var org "Organization"
lab var prop "Propaganda"
lab var youth_league "Youth League"
lab var firstjob_yr "Years of Work Experience"
lab var party_yr "Years of Party Membership"
lab var purgeconnection "Purge Intensity*Connection"


* Table G.1: Winners vs. Peers
balancetable sec_promotion first_con_ps female minority edu sec_age ps_term  firstjob_yr party_yr gdp_pc_rel  fiscal_gdp_rel dic  law_enforce org prop youth_league using "t_test.tex" ,replace varlabel  wide(mean sd pval) pvalues staraux ///
            ctitles("Mean" "SD" "Mean" "SD" "P-value of T-test")
